<html>
  <body>
    <h3>JDBC setup</h3>
    In order to test opb-core, you need the Oracle JDBC drivers in your local maven repository.
    <ol>
        <li>
            <a href="http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html">
                Download the JDBC drivers
            </a>
            <ol>
                <li>
                    Oracle Database 11g Release 2 (11.2.0.3) JDBC Drivers for use with JDK 1.5
                </li>
            </ol>
        </li>
        <li>
            Install the file into your local maven repository
            <ol>
                <li>
                    Rename ojdbc5.jar to ojdbc5-11.2.0.3.jar
                </li>
                <li>
                    mvn install:install-file -D"file=./ojdbc5-11.2.0.3.jar" -D"groupId=oracle"
                    -D"artifactId=oracle-jdbc" -D"version=11.2.0.3" -D"packaging=jar"
                </li>
            </ol>
        </li>
    </ol>

    <h3>Database set-up for opb-core</h3>

    To run the unit tests, you need to set-up a database account;

    <ol>
        <li>
            Create the DB account (opb_test). e.g. Run the following commands via SQL*Plus;
            <ul>
                <li>CREATE USER opb_test DEFAULT TABLESPACE users IDENTIFIED BY weak_pw;</li>
                <li>
                    GRANT DBA TO opb_test;
                    <ul>
                        <li>
                            Granting DBA to opb_test is the quickest way to ensure that the test
                            user has enough privileges - but you wouldn't do this in production.
                        </li>
                    </ul>
                </li>
            </ul>
        </li>
    </ol>

    Database connection details for the test suite can be found in helpers.TestHelper.java.
    See TestHelper#getOracleDataSource().

    The default DB connection details are;
    <ul>
        <li>url=jdbc:oracle:thin:@//localhost:1521/xe</li>
        <li>user=opb_test</li>
        <li>password=weak_pw</li>
    </ul>

    This URL will work if you have a local copy of Oracle XE running.
    <br/>
    If you would like to use a different URL or user, please edit helpers.TestHelper.

  </body>

</html>
